Currently I working to set up a small buisness (electronics distribution) intranet. I am using Windows 2000, access 2000, and MySQL 3.23.28.
We have large amounts of information stored in many access databases. They need to be in MySQL because of the setup we've chosen (my hand was forced by Adobe Golive support). I'm importing using MyODBC - which works fine, except for the data types. In access, strings are defined as "text", I believe this to be the microsoft equivalent to varchar in MySQL (corect me if im wrong??). However when inspecting the table in MySQL, the data type is text, in MySQL terms, a case-insensitive Blob. This now prevents me from being able to use the WHERE clauses my filters use on my site. I am trying to avoid changing each table as it is imported. Can anyone help me???
Take a look at this page http://www.mysql.com/portal/software/html/software-37-1.html
Have you tried with the Import function ,of MySQLFront (http://www.anse.de/mysqlfront/)? It's very powerful
Thanks, I'm using MySQLFront and its working admirably!
ok, now ive come to the task of having to convert an access DB to mysql. my main problem is with the text fields in access. when i export the DB using an odbc datasource through access, the resulting mysql DB also have text fields(id rather they be varchar) which are blob fields.
what tools out there will convert the text fields to varchar instead of leaving them as text.
also, which of the acces-to-mysql tools will allow you to do database-wide changes such as marking all fields not null etc.
presently, im using MySQL control center to manualy make all the needed changes. however, i know i will be doing this again soon, so i need a good coversion tool and soon!